﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace FortuneHeavenCommon.DataMap
{
    public partial class GameScoreInfo
    {
        public const string TABLE_NAME = "GameScoreInfo";
        public const string INSERT_SQL = "insert into GameScoreInfo([UserID],[Score],[Revenue],[InsureScore],[WinCount],[LostCount],[DrawCount],[FleeCount],[UserRight],[MasterRight],[MasterOrder],[RegisterIP],[LastLogonIP],[RegisterDate],[LastLogonDate],[AllLogonTimes],[PlayTimeCount],[OnLineTimeCount],[Coupon]) values (@UserID,@Score,@Revenue,@InsureScore,@WinCount,@LostCount,@DrawCount,@FleeCount,@UserRight,@MasterRight,@MasterOrder,@RegisterIP,@LastLogonIP,@RegisterDate,@LastLogonDate,@AllLogonTimes,@PlayTimeCount,@OnLineTimeCount,@Coupon)";
        public const string UPDATE_SQL = "UPDATE GameScoreInfo SET [UserID]=@UserID,[Score]=@Score,[Revenue]=@Revenue,[InsureScore]=@InsureScore,[WinCount]=@WinCount,[LostCount]=@LostCount,[DrawCount]=@DrawCount,[FleeCount]=@FleeCount,[UserRight]=@UserRight,[MasterRight]=@MasterRight,[MasterOrder]=@MasterOrder,[RegisterIP]=@RegisterIP,[LastLogonIP]=@LastLogonIP,[RegisterDate]=@RegisterDate,[LastLogonDate]=@LastLogonDate,[AllLogonTimes]=@AllLogonTimes,[PlayTimeCount]=@PlayTimeCount,[OnLineTimeCount]=@OnLineTimeCount,[Coupon] =@Coupon where UserID = @UserID";

        /// <summary>
        ///
        /// </summary>
        public int UserID
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public double Score
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public double Revenue
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public double InsureScore
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public int WinCount
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public int LostCount
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public int DrawCount
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public int FleeCount
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public int UserRight
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public int MasterRight
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public int MasterOrder
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string RegisterIP
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string LastLogonIP
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public DateTime RegisterDate
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public DateTime LastLogonDate
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public int AllLogonTimes
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public int PlayTimeCount
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public int OnLineTimeCount
        {
            get;
            set;
        }

        public int Coupon
        {
            get;
            set;
        }
    }

}
